Creating an Extract Report

Introduction

An Extract Report is designed to create output files that meet pre-defined specifications.  This feature is especially useful for creating delimited output that is more complex than a simple comma-separated file (CSV), for creating a fixed-width file in which each field is precisely positioned on a given line, or for creating an XML file.  This could include files that you might upload to a government agency, clearinghouse, or service bureau.

Extract Reports are somewhat similar in design to a Banded Report.  Similar to bands within a Banded Report, an Extract Report has sections, each of which can include different data fields.  However, in an Extract Report you can loop through as many datasets as your report requires, and you can precisely control the position of your data in the output file.

Unlike a Banded Report, there is no concept of a “page” in an Extract Report.  Data is simply streamed into an output file.

This image shows a comparison of a Banded Report versus an Extract Report.

Available report formats:

Sections in the Extract Report

The output file from an Extract report is organized by sections. You can add as many sections as you like to the Extract Report design. The definition of each type of section is as follows:

You can create multiple Detail sections in an output file. You might have one simply follow another. For example, if you wanted a list of all regular checks, followed by a list of all voided checks, you would simply add a pair of Detail sections. Each Detail section is associated with its own dataset, and can be formatted however you require.

Another option is to make a Detail section a “parent” of a subsequent Detail section (referred to as the Sub-Detail section). For each record that is output in the parent Detail section, the Sub-Detail section will be executed and added to the file as well. In the vendor example from above, the vendor would be in the parent Detail section, with a list of invoices in the Sub-Detail section. You can have multiple “levels” of Sub-Detail sections.   Like a Banded Report, using Sub-Detail sections in an Extract Report can significantly impact the amount of time needed to generate the report.  Use this technique only if Headers and Footers (below) do not meet your requirements.